ServicerProcessGlobalExtract

EntityType | Independent
Logical Entity Name | ServicerProcessGlobalExtract
Default Table Name | FaGlobalExtract
Logical Only | NO
Owner | dbo
Definition |
Note |

ServicerProcessGlobalExtract Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
SchoolNumber |  | CHAR(4) | YES |
StudentIdentifier |  | CHAR(9) | YES |
TermCode |  | CHAR(6) | YES |
TermBeginDate |  | CHAR(6) | YES |
TermEndDate |  | CHAR(6) | YES |
LastName |  | CHAR(15) | YES |
FirstName |  | CHAR(12) | YES |
MiddleInitial |  | CHAR(1) | YES |
StartDate |  | CHAR(6) | YES |
ExtractDate |  | CHAR(6) | YES |
EnrollmentStatusLevel |  | CHAR(1) | YES |
SapFlag |  | CHAR(1) | YES |
AttendanceFlag |  | CHAR(1) | YES |
EnrollmentStatusCode |  | CHAR(1) | YES |
LDAwithdrawal |  | CHAR(6) | YES |
LDAgraduate |  | CHAR(6) | YES |
EstimatedEnrollmentStatus |  | CHAR(1) | YES |
Filler1 |  | CHAR(1) | YES |
EnrollmentDate |  | CHAR(6) | YES |
GPA |  | CHAR(5) | YES |
ProgramTotalHours |  | CHAR(7) | YES |
CumulativeHoursCompleted |  | CHAR(7) | YES |
CurrentScheduledHours |  | CHAR(6) | YES |
WithdrawalDod |  | CHAR(6) | YES |
SapProgressPct |  | CHAR(7) | YES |
StudentId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
IsLastExtractFlag |  | BIT | NO |
IsExtractFlag |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
ClockToCredit |  | CHAR(1) | YES |
ServicerProgramIdentifier |  | VARCHAR(16) | YES |
CampusId |  | INTEGER | YES |
PackagingStatusCode |  | VARCHAR(8) | NO |

ServicerProcessGlobalExtract Keys

Key Name | Key Type | Keys
FaGlobalExtract_EnrollmentStatusCode_AdEnrollID_N_N_IDX | Inversion Entry | EnrollmentStatusCode, StudentEnrollmentPeriodId
FaGlobalExtract_AdEnrollID_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId
FaGlobalExtract_FaGlobalExtractID_U_C_IDX | PrimaryKey | Id

ServicerProcessGlobalExtract Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
FaGlobalExtractChildTerm | Non-Identifying | One To Zero or More |  |  |  |  | NO

ServicerProcessGlobalExtract Check Constraints

Check Constraint Name | CheckConstraint

ServicerProcessGlobalExtract Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ServicerProcessGlobalExtract | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaGlobalExtract | NO |  |  |

ServicerProcessGlobalExtract Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

ServicerProcessGlobalExtract Data Movement Rules

Name | Type | Rule Text/Value